Next, we will set up the drill through information buttons.
Step 1: Configure Drill Through in the ZipCode Dashboard page
In Power BI Desktop, click on the page, ZipCode
If selected, de-select a visualization by clicking an empty area of the report page.
Under Drill through -> Cross-report -> Set it to OFF , Keep all filters -> Set it to ON and add drag the following value underneath:
Township -> Township_Name
Step 2: Configure Drill Through in the Township Dashboard page
In Power BI Desktop, click on the page, ZipCode
If selected, de-select a visualization by clicking an empty area of the report page.
Under Drill through -> Cross-report -> Set it to OFF , Keep all filters -> Set it to ON and add drag the following value underneath:
Table_AptPricePerUnit_PerPricePerSqFt -> Physical_Zip_Code , Allow drill through when = Used as category
Property -> Physical_Zip_Code , Allow drill through when = Used as category
Township -> Township_Name
Step 3: Create a Drill Through Information Button on Dashboard 02
In Power BI Desktop, click on the page, WakeCountyRealEstate
Click Insert tab -> Buttons and select Information
Visualizations
Click the Information icon
Fields
N/A
Visualizations (Format button)
Under Visualizations (Format button) -> General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121
Under Visualizations (Format button) -> Button Text -> Set it to OFF
Under Visualizations (Format button) -> Icon -> Set it to ON = Default State , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 8 pt
Under Visualizations (Format button) -> Title -> Set it to ON , Title Text = Drill Through 1 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)
Under Visualizations (Format button) -> Background -> Set it to ON , Color = #FFFFFF
Under Visualizations (Format button) -> Border -> Set it to ON , Color = #666666 , Radius = 5 px
Under Visualizations (Format button) -> Action -> Type = Drill Through , Destination = ZipCode
Step 4: Create a Drill Through Information Button on Dashboard 03, ZipCode
Copy the Information from Dashboard 02 and use it as a template.
Click on the 'Drill Through 1 of 3' from Dashboard 02 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, ZipCode
From the copied 'Drill Through 1 of 3' from Dashboard 02, ZipCode, to this dashboard, set up as follows:
Visualizations (Format button)
Under Visualizations (Format button) -> General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121
Under Visualizations (Format button) -> Button Text -> Set it to OFF
Under Visualizations (Format button) -> Icon -> Set it to ON = Default State , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt
Under Visualizations (Format button) -> Title -> Set it to ON , Title Text = Drill Through 2 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)
Under Visualizations (Format button) -> Background -> Set it to ON , Color = #FFFFFF
Under Visualizations (Format button) -> Border -> Set it to ON , Color = #666666 , Radius = 5 px
Under Visualizations (Format button) -> Action -> Type = Drill Through , Destination = Township
Step 5: Create a Drill Through Information Button on Dashboard 04, Township
Click on the 'Drill Through 1 of 3' from Dashboard 02 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, Township
From the copied 'Drill Through 1 of 3' from Dashboard 02, WakeCountyRealEstate, to this dashboard, set up as follows:
Visualizations (Format button)
Under Visualizations (Format button) -> General: X Position = 1320 , Y Position = 0 , Width = 180 , Height = 121
Under Visualizations (Format button) -> Button Text -> Set it to OFF
Under Visualizations (Format button) -> Icon -> Set it to ON = Default State , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt
Under Visualizations (Format button) -> Title -> Set it to ON , Title Text = Drill Through 3 of 3 , Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)
Under Visualizations (Format button) -> Background -> Set it to ON , Color = #FFFFFF
Under Visualizations (Format button) -> Border -> Set it to ON , Color = #666666 , Radius = 5 px
Under Visualizations (Format button) -> Action -> Set it to OFF
When finished, save project.
How to Set up drill through in Power BI reports